#pragma once
#include "defines.h"
#include "Logger.h"
#include <mysql.h>
#include <string>
#include <windows.h>

using namespace std;
class SQL_Conn
{

private:
	MYSQL* mysql;
	MYSQL_STMT* stmt;

public:
	SQL_Conn();
	~SQL_Conn();
public:

	bool insert_originRFID_Data(string device_id, string ant_id, string epc, string start_time);

	unordered_map<string, string> select_epc_isNest();

	bool insert_Scale_enter_exit_record(string device_id, string epc, string endTime, string direction);

	bool insert_length_of_time_record(string device_id, string epc, string enterTime, string endTime, string timeGap, int already_nestle);

};
